Skip to main content

Schedule Delta Analysis

A week-over-week Schedule Delta Analysis compares two schedule datasets and generates a structured report across four output categories.

Output Categories​

1. Frequency Changes​

Routes where a single carrier has increased or decreased scheduled flights week-over-week. Includes:

  • Carrier code
  • Origin-destination pair (IATA codes)
  • Frequency in previous and current week
  • Frequency change (e.g. +2 or -1)
  • Effective days of operation

2. New Routes Loaded​

New origin-destination pairs operated by any carrier that appear in the current week but were not in the previous week. Includes:

  • Carrier code
  • Origin and destination
  • Aircraft type and frequency
  • Days of operation

3. Routes Terminated​

Routes operated in the previous week that are not operated in the current week. Includes:

  • Carrier code
  • Origin-destination pair
  • Aircraft type and previous frequency

4. Aircraft Type Change (No Frequency Change)​

Routes where weekly frequency is unchanged but aircraft type has changed to one with either higher seat capacity (upgauge) or lower seat capacity (downgauge). Includes:

  • Carrier code
  • Origin-destination pair
  • Previous aircraft type → current aircraft type
  • Estimated seat change (if available)
  • Upgauge or downgauge indicator

Prompt​

Compare this week's published SSIM to last week's published SSIM and generate a structured report with the following four outputs: Frequency Changes: Identify routes where a single carrier has increased or decreased the number of scheduled flights week-over-week. For each change, include: carrier code, origin-destination pair (IATA codes), frequency in previous and current week, frequency change (e.g. +2 or -1), effective days of operation. New Routes Loaded: Identify any new routes operated by any carrier that appear in the second week's schedule but were not present in the first week's schedule. For each new route, include: carrier code, origin and destination (IATA codes), aircraft type, weekly frequency, days of operation. Routes Terminated: Identify any routes that were operated by a carrier in the first week but are not operated in the second week. For each terminated route, include: carrier code, origin-destination pair (IATA codes), aircraft type, weekly frequency from previous week. Aircraft Type Change (No Frequency Change): Highlight OD pairs where the weekly frequency has remained the same, but the aircraft type has changed. Include: carrier code, origin-destination pair, previous aircraft type and current aircraft type, estimated seat change (if available), and whether it is an upgauge or downgauge. Only include routes with actual differences in the report. Format results in clearly separated tables for each of the four categories. If possible, include sorting options by carrier or route and include actionable insights.

How Maestrow Processes This​

1. Schedule Ingestion and Normalisation​

  • Parse two schedule snapshots (SSIM, Excel, or JSON format)
  • Normalise fields: carrier code, flight number, departure/arrival airports, days of operation, aircraft type, effective/discontinue dates

2. Indexing by Key Dimensions​

  • Create route-level keys using Carrier|Origin|Destination
  • Count weekly frequencies by parsing days of operation or specific flight records
  • Cross-reference aircraft types with internal seat capacity database

3. Analysis Modules​

Frequency Delta Engine — compare weekly flight counts by route and carrier; categorise as increased or decreased.

New Route Detector — identify route keys in the current schedule not found in the previous schedule; cross-check effective dates to avoid false positives.

Route Termination Detector — identify routes that existed previously but are now missing; validate against discontinue dates and seasonal suspensions.

Aircraft Change Detector — for routes with the same frequency, check aircraft type; map codes (e.g. 320, 321, 788) to seat capacities; flag upgauge/downgauge based on capacity delta.

Output Generation — structured tabular format with filters by carrier, route, or aircraft type; export to CSV or dashboard.